 CREATE EXTERNAL TABLE jms_dm.dm_tab_business_monitor_summary_dt
(

   agent_code                      string comment '代理区',
   customer_code                   string comment '客户code',
   order_source_code               string comment '订单来源code',
   false_taking_site_code          string comment '操作网点code',
   agent_name                      string comment '代理区code',
   customer_name                   string comment '客户name',
   order_source_name               string comment '订单来源name',
   false_taking_site               string comment '操作网点',
   false_taking_cnt                bigint comment '虚拟揽收操作量',
   real_taking_cnt                 bigint comment '真实揽收操作量',
   network_send_cnt                bigint comment '虚拟网点发件量',
   store_arrival_cnt               bigint comment '虚拟集货到件量',
   entrepot_send_cnt               bigint comment '虚拟集散发件量',
   center_send_cnt                 bigint comment '虚拟中心发件量',
   center_arrival_cnt              bigint comment '虚拟中心到件量',
   send_over_one_day_cnt           bigint comment '中心发出超时24小时票数',
   send_over_two_day_cnt           bigint comment '中心发出超时48小时票数',
   taking_over_half_day_cnt        bigint comment '超时揽收票数12小时',
   taking_over_one_day_cnt         bigint comment '超时揽收票数24小时',
   taking_over_two_day_cnt         bigint comment '超时揽收票数48小时',
   date_time                       date comment '分区时间'
) COMMENT '操作平台-商务件监控统计' PARTITIONED BY (
    `dt` string)
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_tab_business_monitor_summary_dt'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );



 CREATE EXTERNAL TABLE jms_dm.dm_tab_business_monitor_contrast_dt
(

   statistic_date                date comment '扫描天',
   statistic_hour                  string comment '扫描小时',
   statistic_format_date           string comment '格式化时间',
   scan_cnt                        bigint comment '扫描数量'

) COMMENT '操作平台-商务件监控对比' PARTITIONED BY (
    `dt` string)
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_tab_business_monitor_contrast_dt'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );